home *** CD-ROM | disk | FTP | other *** search
/ Chip 2002 February / CHIPCD_02_2002.iso / Internet / Macromedia ColdFusion Server 5 / coldfusion-50-win-us.exe / data1.cab / Examples / CFDOCS / snippets / cftree.cfm < prev    next >
Encoding:
Text File  |  2001-06-13  |  4.6 KB  |  83 lines
  1. <!--- This example shows the use of CFTREE, CFSELECT and CFGRID in a CFFORM.
  2. The query takes a list of employees, and uses CFTREE and CFSELECT
  3. to display the results of the query.  In addition, CFGRID is used
  4. to show an alternate means of displaying the same data --->
  5.  
  6. <!--- set a default for the employeeNames variable --->
  7. <CFPARAM name="employeeNames" default="">
  8.  
  9. <!--- if an employee name has been passed from the form,
  10. set employeeNames variable to this value --->
  11. <CFIF IsDefined("form.employeeNames")>
  12.     <CFSET employeeNames = form.employeeNames>
  13. </CFIF>
  14.  
  15. <!--- query the datasource to find the employee information--->
  16. <CFQUERY NAME="GetEmployees" DATASOURCE="cfsnippets">
  17. SELECT   Emp_ID, FirstName, LastName, EMail, Phone, Department
  18. FROM     Employees Where 0 = 0 <CFIF employeeNames is not "">AND LastName = '#employeeNames#'</CFIF>
  19. </CFQUERY>
  20.  
  21. <HTML>
  22. <HEAD>
  23. <TITLE>
  24. CFTREE Example
  25. </TITLE>
  26. </HEAD>
  27.  
  28. <BASEFONT FACE="Arial, Helvetica" SIZE=2>
  29. <BODY  bgcolor="#FFFFD5">
  30.  
  31. <H3>CFTREE Example</H3>
  32.  
  33. <!--- Use CFFORM when using other CFINPUT tools --->
  34. <CFFORM ACTION="cftree.cfm" METHOD="POST" ENABLECAB="Yes">
  35.  
  36. <!--- Use CFSELECT to present the contents of the query by column --->
  37. <H3>CFSELECT Presentation of Data</H3>
  38. <H4>Click on an employee's last name and hit "see information for
  39. this employee" to see expanded information.</H4>
  40. <CFSELECT NAME="EmployeeNames" MESSAGE="Select an Employee Name" SIZE="#getEmployees.recordcount#" QUERY="GetEmployees" VALUE="LastName" REQUIRED="No">
  41. <OPTION value="">Select All
  42. </CFSELECT>
  43.  
  44. <INPUT TYPE="Submit" NAME="" VALUE="see information for this employee">
  45.  
  46. <!--- showing the use of CFTREE --->
  47.  
  48. <!--- Use CFTREE for an expanded presentation of the data --->
  49. <!--- Loop through the query to create each branch of the CFTREE --->
  50. <H3>CFTREE Presentation of Data</H3>
  51. <H4>Click on the folders to "drill down" and reveal information.</H4>
  52. <P>CFTREEITEM is used to create the "branches" of the tree.
  53. <P><CFTREE NAME="SeeEmployees" HEIGHT="150" WIDTH="240" FONT="Arial Narrow" BOLD="No" ITALIC="No" BORDER="Yes" HSCROLL="Yes" VSCROLL="Yes" REQUIRED="No" COMPLETEPATH="No" APPENDKEY="Yes" HIGHLIGHTHREF="Yes">
  54. <CFLOOP QUERY="GetEmployees">
  55. <CFTREEITEM VALUE="#Emp_ID#" PARENT="SeeEmployees" EXPAND="No">
  56. <CFTREEITEM VALUE="#LastName#" DISPLAY="Name" PARENT="#Emp_ID#" QUERYASROOT="No" EXPAND="No">
  57.     <CFTREEITEM VALUE="#LastName#, #FirstName#" PARENT="#LastName#" EXPAND="No" QUERYASROOT="No">
  58. <CFTREEITEM VALUE="#Department#" DISPLAY="Department" PARENT="#Emp_ID#" QUERYASROOT="No" EXPAND="No">
  59.     <CFTREEITEM VALUE="#Department#" PARENT="#Department#" EXPAND="No" QUERYASROOT="No">
  60. <CFTREEITEM VALUE="#Phone#" DISPLAY="Phone" PARENT="#Emp_ID#" QUERYASROOT="No" EXPAND="No">
  61.     <CFTREEITEM VALUE="#Phone#" PARENT="#Phone#" EXPAND="No" QUERYASROOT="No">
  62. <CFTREEITEM VALUE="#Email#" DISPLAY="Email" PARENT="#Emp_ID#" QUERYASROOT="No" EXPAND="No">
  63.     <CFTREEITEM VALUE="#Email#" PARENT="#Email#" EXPAND="No" QUERYASROOT="No">
  64. </CFLOOP>
  65. </CFTREE>
  66.  
  67. <!--- You can also use CFGRID for a more comprehensive, quicker
  68. view at the data --->
  69. <H3>CFGRID Presentation of Data</H3>
  70.  
  71. <CFGRID NAME="SampleGrid" WIDTH="600" QUERY="GetEmployees" INSERT="No" DELETE="No" SORT="No" FONT="Verdana" BOLD="No" ITALIC="No" APPENDKEY="No" HIGHLIGHTHREF="No" GRIDDATAALIGN="LEFT" GRIDLINES="Yes" ROWHEADERS="No" ROWHEADERALIGN="LEFT" ROWHEADERITALIC="No" ROWHEADERBOLD="No" COLHEADERS="Yes" COLHEADERALIGN="CENTER" COLHEADERITALIC="No" COLHEADERBOLD="No" BGCOLOR="Teal" SELECTMODE="BROWSE" PICTUREBAR="No">
  72. <CFGRIDCOLUMN NAME="LastName" HEADER="Last Name" HEADERALIGN="LEFT" DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="Yes" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  73. <CFGRIDCOLUMN NAME="FirstName" HEADER="First Name" HEADERALIGN="LEFT" DATAALIGN="LEFT" FONTSIZE="2" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  74. <CFGRIDCOLUMN NAME="Email" HEADER="Email" HEADERALIGN="LEFT" DATAALIGN="LEFT" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  75. <CFGRIDCOLUMN NAME="Phone" HEADER="Phone" HEADERALIGN="LEFT" DATAALIGN="LEFT" BOLD="No" ITALIC="Yes" SELECT="No" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  76. <CFGRIDCOLUMN NAME="Department" HEADER="Department" HEADERALIGN="LEFT" DATAALIGN="LEFT" BOLD="Yes" ITALIC="No" SELECT="No" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  77. <CFGRIDCOLUMN NAME="Emp_ID" HEADER="ID" HEADERALIGN="LEFT" DATAALIGN="LEFT" WIDTH="40" BOLD="No" ITALIC="No" SELECT="No" DISPLAY="Yes" HEADERBOLD="No" HEADERITALIC="No">
  78. </CFGRID>
  79. </CFFORM>
  80.  
  81. </BODY>
  82. </HTML>       
  83.